<?php
class Admin_Models_ProductModel extends Zend_Db_Table_Abstract{
	protected $_name="product";
	protected $_primary="id";
	function getProdctList($arrParam){
		$db = Zend_Db_Table::getDefaultAdapter();
    	$mySql = $db->select()
    				->from(array("p"	=> "product"),array('id','name',"developer",'icon','download','update','status'))    	
					->join(array("c"	=> "category"), "p.category_id = c.id",array('product_type'	=> "type"))					
    				->where("p.os = ?",$arrParam['os'])
    				->where("p.status = ?",1)
    				->order("p.id DESC");
		$result = $db->fetchAll($mySql);
		return $result;
	}
	
}